SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552630 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552630 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591101,342151,554839,239118,324118,273671,488001,593388,809489,14765,754770,695766,302887,701366,876385,488632,559731,195597,281190,115629,429406,176426,778605,87281,186207,813402,643783,663899,827722,480410,183691,371792,196952,480340,535611,242540,536913,930327,663143,462891,546605,621226,247428,488498,133500,554020,736606,352324,76177,1047897,921690,381253,639120,187945,170862,422911,486376,271877,440084,598257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]