SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403568 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403568 [ RunTime:0.003825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92361,324087,752813,356867,226672,417893,857158,587722,600095,877607,980311,276372,237118,248834,774553,982172,24152,886078,94540,971100,30394,149462,478539,926459,449677,116770,1003946,901722,285077,563765,494493,752377,915925,130157,216633,65420,689894,954434,75552,720632,235561,312532,536499,76277,913103,459365,760155,769422,856535,859218,711759,394610,149798,279780,522561,285123,491781,1043192,364774,406230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]