SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654510 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654510 [ RunTime:0.002996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419299,918506,239773,145656,919912,308785,1020132,507622,407714,969395,533013,67668,556943,217646,469799,1037501,173830,521028,425586,1000196,482472,626762,519153,790473,74831,346136,844520,343375,525010,429085,43158,1004657,337066,302898,437549,772421,195720,224388,594802,907755,567836,940688,959105,295843,1005619,976672,979680,314788,192182,94189,1031649,385954,312383,433161,528663,49915,539754,104501,802270,277847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]