SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031228 LIMIT 1 [ RunTime:0.001920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031228 [ RunTime:0.006231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98380,214474,197455,517748,106270,939964,594122,608544,194080,433316,195298,971874,471159,977090,106906,908407,787328,889799,325921,989132,791437,154117,678883,1002702,615286,473806,15225,779725,1012092,481189,228678,2122,862847,957055,196816,226342,29447,7964,437237,310635,602076,367348,112878,750903,934709,145412,256203,508828,142669,702472,436447,580924,351013,616728,445091,237114,807554,204342,155262,677410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002213s ]