SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201491 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201491 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438919,817761,402315,793244,452883,802851,134245,170369,103415,369195,354849,330943,909030,154105,50464,1047796,347898,239887,177439,875670,1008714,299596,860722,446974,797380,575508,65946,1028909,208069,751405,510950,819936,427444,618388,246032,536127,720385,456425,1033682,783686,574045,47730,558766,16480,413985,369704,32656,521159,592369,377427,618259,714655,1002222,220368,21255,349790,341761,517348,238474,750450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]