SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506104 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506104 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114364,490533,105702,402123,400687,67569,360436,86046,1033500,295948,607021,510659,955240,450506,432528,115101,438928,373073,420640,976813,648971,784611,522014,782571,941033,461525,505870,928823,741510,114227,22732,248975,502924,5062,321191,730624,71360,106800,167839,201158,46658,288211,564188,83785,546592,839101,279515,1037827,310792,886654,21502,718699,53457,53414,1033664,52063,295866,553600,477781,677011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]