SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565505 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565505 [ RunTime:0.003671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903426,678464,1048716,371662,465918,618794,432503,25579,960070,867896,1045771,271666,568674,856983,77033,397842,918461,78051,39288,326990,100023,575038,311093,844600,67121,803814,876873,762498,974595,511301,942477,775377,990637,436416,784867,13090,120591,305643,821532,999180,511327,284047,556117,124134,748755,1032283,341336,67817,308084,839758,677232,162009,377742,731726,389638,882527,29728,586275,1029622,422205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]