SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574271 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574271 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80499,206294,935939,923835,56034,853489,931672,964506,714823,849596,234271,957062,197439,13119,382438,569935,573647,724110,909550,267749,913387,21719,698849,373072,290929,560086,111520,259227,715685,905920,795770,180970,867878,79599,880935,525758,598392,804689,847217,142857,583004,467136,313084,6814,717755,81345,283225,758658,423413,389227,596633,558042,302801,230520,71649,32048,801502,723519,287167,411453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]