SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461041 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461041 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835607,102678,280954,829279,189887,352054,859465,685962,341564,887658,184529,120913,493610,165769,554167,561179,317612,233380,800742,65164,430904,432381,14712,357368,600773,898171,471386,601173,497085,537104,48027,488134,899999,520659,343129,463708,173060,509338,633254,474396,446353,614560,981735,956424,591220,564756,851335,64869,323257,857659,695537,198122,143823,497447,154385,798606,687982,612321,692217,660503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]