SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820094 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820094 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549699,407713,80083,1041475,539212,913814,307838,523873,828883,775704,631003,893720,414249,320851,644214,15187,100679,774830,662499,470578,919530,210015,603655,890658,12318,249227,4500,476410,364919,182778,570241,359196,57185,324570,1004078,711655,759004,788379,512507,398969,830520,962579,834997,162035,739097,937146,222677,586931,705065,974378,168368,173847,1003379,990198,276339,848395,30952,229517,91215,873837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]