SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019416 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019416 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644954,555647,852552,769326,985206,968188,155014,331958,55661,733599,1034506,840311,604251,401595,40383,470460,22741,802113,800752,311093,198223,212144,636538,919393,287546,969965,563020,662191,851814,512107,555979,235011,244350,265757,49803,332186,490071,419285,172868,27751,90871,449143,438014,62959,988172,1020730,918665,90518,729750,189669,43123,605035,313267,185075,558565,998653,816069,494098,355721,635253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]