SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5398 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5398 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482051,7206,963015,752047,30902,1001958,652385,118881,879855,359178,275561,779029,845204,557041,390413,922619,757532,514120,410574,243341,291615,233964,701738,94509,431352,674190,667082,802724,660228,466814,924790,829303,345225,74017,508506,12853,848757,222886,822230,944896,720686,949543,994134,1042242,875559,444954,873697,918921,800326,175588,496316,130793,726450,772976,654774,208123,211591,300592,868237,13094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]