SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 624416 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 624416 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011961,204042,540072,646241,134429,1020253,594013,269217,434648,509856,201268,752520,557041,859452,847121,552110,25997,184863,915489,90229,39930,105456,841099,657161,549229,31152,699927,588999,973245,780404,80889,504493,600683,505084,137846,294504,54207,724276,244386,1011635,574870,130466,761189,887311,140427,929682,300462,355026,794985,28591,401198,297936,285326,46961,874915,338294,133136,82495,1035535,919471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 624416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 624416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]