SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022143 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022143 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462872,260928,450158,189695,994541,209164,856464,473470,979427,38140,878422,636759,121907,694980,998747,225407,411956,722866,235522,215101,591887,29195,789822,685392,525474,26053,942091,240247,733849,125731,351508,609515,859740,774593,673262,114988,32663,99341,348107,673559,79426,521530,585961,773893,485843,159375,681650,329617,603220,337737,424540,981133,756022,767533,600135,749069,906906,218982,464906,256270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]