SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10496 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10496 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658772,955663,828165,439721,1038971,724310,794431,348515,751434,281950,766097,910814,820838,182386,510805,235135,165141,315140,1031921,436551,405798,164873,115966,723596,26496,108413,259379,202490,641055,499600,658338,540309,828377,246438,648734,480760,923532,2092,461786,654420,954146,675486,931728,365035,1001369,621520,982780,229533,810804,663475,797260,404814,401981,654836,1016427,569624,285947,244660,489732,388149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]