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` = 253317 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253317 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803300,282360,525910,985614,13745,129253,346435,427253,783445,580975,680574,1005180,806260,414048,622270,81624,495414,798565,964190,589634,667124,116898,632624,173218,889912,275051,904952,926485,998809,782000,232908,359224,644556,1048629,772724,1032108,855730,434185,409110,570327,181045,945495,567832,145438,390914,367812,568379,268828,639200,829045,460655,710646,3920,628448,470855,505688,826605,901955,197642,490234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]