SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542541 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542541 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947677,580332,237682,449553,573592,737152,587576,881095,1036299,378511,717695,158899,693865,714773,441201,904610,905976,649313,1015096,826847,14558,749111,935306,18882,940849,151058,974446,513873,508013,130048,671080,563694,746820,647344,636979,727091,616151,610132,472191,757943,779522,880511,350734,1018903,815035,442451,41427,771240,578138,63101,310093,72790,967067,270493,726992,103147,1018900,1037515,12602,585578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000940s ]