SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311979 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311979 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401781,5481,679266,862582,754533,1006668,272487,347147,647694,914420,893613,323618,584659,842805,428654,840012,1009355,267708,677457,218941,471145,621051,11876,959299,447851,43380,677862,549300,549637,615248,86398,748219,434481,108273,447940,489187,862583,494233,708613,867190,427582,211384,940853,376880,470216,301179,900644,663604,517712,35914,707888,683803,897603,592487,340186,622103,506814,783447,1015723,934699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004420s ]