SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030843 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030843 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690166,850548,237011,814647,200888,643741,781949,312434,754077,618973,1035043,1015477,456783,218101,377319,823405,24990,515362,255225,129117,673540,750471,25955,561753,807842,675747,12856,933556,274234,188064,835372,108016,452502,995475,711820,749186,964579,188946,30037,196717,252498,586010,140291,242601,741101,435788,234574,255375,597239,549153,715806,192445,449012,1045967,748264,835218,175103,340008,94392,959657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]