SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401056 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401056 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238631,501351,541988,436379,187865,417834,657713,581257,150990,302760,112959,109619,230343,1018198,313357,472442,822162,118391,805812,342126,837660,501654,211267,276051,960232,732885,293594,748161,138897,22694,596319,196706,425295,203673,721587,906114,605218,800130,700079,629839,860587,702904,930076,455048,834603,55955,924672,1047996,90867,473981,835251,934996,311927,159591,985592,842521,417357,390264,373524,612687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]