SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426411 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426411 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021752,82337,695940,840532,973018,826464,566655,725981,739994,1010119,686623,696632,918815,418820,42527,971700,757129,745311,352389,832107,1045630,742611,154393,12808,352338,965347,919813,516989,929510,1021346,610013,646525,918112,1001217,389785,224726,439796,701697,842241,520705,812041,492700,267078,788299,196849,190994,105989,138903,309587,596505,289824,234054,122649,455497,462842,603249,862845,422479,244727,637192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]