SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002672s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426076 LIMIT 1 [ RunTime:0.003763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426076 [ RunTime:0.004083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346761,3020,4682,375767,621876,823825,431253,651349,849455,466528,705114,544224,201770,574175,712422,571797,749621,409499,26949,441356,658178,916311,1011386,74263,82640,443324,421113,986343,1024630,87761,656289,550844,1032155,780823,145541,737244,473077,737136,234205,161927,954576,254431,139344,176721,44909,292795,877184,926334,381429,402204,945433,271188,163059,843709,642782,706869,771122,35886,727480,51944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]