SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104860 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104860 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294604,325859,509730,926584,262277,93771,62015,116851,801854,996426,284503,219326,769761,498764,51047,111384,524357,1032883,891296,621933,987087,483285,387578,563617,846653,570300,1011592,374215,470659,54846,114085,945156,313064,890471,138449,1012864,661532,836513,443688,110086,799755,116262,499157,553435,873827,640080,266160,193220,401149,94194,834572,269533,64402,409233,828209,325462,427090,469150,340333,205268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001910s ]