SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294766 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294766 [ RunTime:0.007532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476226,542516,247023,581766,315430,387304,7030,824302,36506,589636,304885,400186,337328,62728,709875,609593,564159,1019519,1039783,61701,228618,1754,546478,232029,267730,541377,912214,786319,509477,336324,506990,1014950,504212,291949,618285,62867,805702,358375,14218,850345,362529,789441,83720,716119,1021285,760943,235531,864957,43399,324006,511583,396274,128792,627433,55653,178112,130611,945843,214745,429347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]