SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461311 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461311 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118324,706968,437857,252874,734044,213262,767456,980833,9078,801776,167444,953537,88222,1027816,185483,556311,815590,929847,368227,426139,487427,957264,603549,424499,62640,150301,806923,108983,781152,247978,10963,623738,45844,1006515,617504,36415,964358,872230,402096,516671,84629,1012203,127592,100033,640467,702598,937468,821020,785547,835771,508750,325952,241545,929844,357504,684109,785751,679686,1038626,79511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]