SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142810 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142810 [ RunTime:0.003941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290943,188572,749301,181815,378463,165055,495541,860312,550304,932683,545934,624516,506734,80756,565270,433928,236425,1008552,651716,944367,616687,442398,334700,700617,83252,250522,656163,553426,898936,395232,201515,858173,387352,879261,957380,486478,812375,703390,786005,490253,822624,121351,187367,427569,252743,971175,678237,34363,56849,12101,918012,139422,33704,760449,7571,912996,132211,973704,338838,1006923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]