SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468505 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468505 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385886,367277,265467,139874,766231,179462,441049,289552,155778,815002,492034,89202,129997,907671,14247,914096,91936,240312,43267,54519,171218,838758,350721,1041105,870497,530650,467513,977538,152903,61182,160954,592879,299182,7759,436054,156725,791087,106465,559024,73117,573914,675666,936894,390757,387319,68056,297039,311531,428445,715215,475395,515484,788304,333457,934325,473126,733423,159370,602553,177197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]