SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532283 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532283 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478493,699292,518520,413376,982039,112832,538744,450781,382935,386209,421034,510646,979938,818999,802846,156840,361994,260994,270762,665493,636615,506316,184299,995414,444808,911811,297264,648825,686257,662905,335927,232400,145441,190565,710473,57261,108972,225727,362723,565139,89528,749765,932674,650827,217843,397932,458292,576978,465054,211934,734213,366839,427357,961980,510828,636869,152657,29376,774097,649878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]