SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106514 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106514 [ RunTime:0.003214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4460,257175,544875,874697,317843,70236,868047,94580,575285,887130,476325,958442,454424,316217,932805,664329,967404,196929,93577,1046679,1022597,984284,585267,836328,716226,101731,479951,526347,160876,478169,433428,46529,722208,783812,498171,528953,590197,564052,420118,655449,474887,882789,43332,734520,15075,320345,580535,810623,1033616,663623,198473,445795,1005363,264491,858921,119659,664097,208270,779976,584743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006338s ]