SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42810 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42810 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291323,444080,784483,833668,425538,828052,889092,861895,497109,167648,999272,568436,780391,66998,175852,421994,36618,615189,672294,436295,993500,485549,547644,547178,192669,1039702,766789,44385,538783,466567,178751,116468,345532,738771,285934,709192,641255,1357,563800,313647,114852,1030616,63341,230352,165849,657271,161030,984223,1033970,359062,952058,972152,1019048,817056,799071,168477,227446,713153,204079,436823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001840s ]