SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405931 LIMIT 1 [ RunTime:0.001583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405931 [ RunTime:0.002840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542534,961036,266246,139388,631621,778765,653664,4622,630590,679045,699379,458171,90723,51617,888061,720185,394059,888583,345085,627490,447537,556572,625037,368959,724010,86285,734457,747099,448952,206816,412098,920922,814565,129678,99559,157632,625007,268611,712989,407858,149229,857157,646424,6348,910426,253566,585088,1021007,390560,511975,814180,776049,490256,1009833,981355,719701,970640,204213,968263,899813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]