SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805035 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805035 [ RunTime:0.006327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113760,745467,112787,980332,554438,814430,550975,497205,126953,547894,86753,605262,465045,731813,207842,449105,389895,306694,592934,1002085,793393,793250,1027561,914496,839246,366374,451725,572917,944346,358667,386453,911267,698808,90197,633397,29715,267207,98689,1023301,373460,905276,557734,974197,1111,322025,797309,252089,262759,915272,820308,688938,649371,399595,191021,36968,1097,860981,966549,632952,879745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]