SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044207 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044207 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11714,24595,126274,955547,906277,116291,777338,418397,661322,975820,845622,595691,905678,143179,1020016,232384,771701,197270,344142,630732,481327,394036,6190,832399,960931,953717,472782,186483,954075,546793,908695,264556,722906,771290,395058,602664,28779,39773,540482,970561,63966,769432,363599,62287,100188,827548,314462,626735,295546,127090,968444,148543,910761,937164,223323,654568,315308,660410,388828,824725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002219s ]