SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986240 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986240 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454083,445526,821776,754312,104001,391788,238489,472294,957066,867533,277492,153777,598151,409551,223092,974818,750497,1009217,396319,884500,570113,624464,834590,151198,787774,807298,377711,254560,411480,794816,208362,727518,127551,1042080,96388,1047019,355094,411626,954997,565828,101679,143375,920237,26965,416680,1014071,20430,991220,431885,803396,112836,201282,704700,399157,753201,252581,543509,26861,742017,572314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]