SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367936 LIMIT 1 [ RunTime:0.001441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367936 [ RunTime:0.003630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260406,158398,175589,803627,250656,544038,627769,330491,172317,641534,327793,890668,345189,616835,279460,708051,307563,657567,112915,324572,113610,537158,359110,872668,702792,769951,461477,281946,967072,304388,294687,347420,619139,285292,79701,602867,14285,976343,153474,508419,733915,1017878,380706,605088,33791,1003294,436460,95170,873800,154359,424643,798714,294178,618406,483933,63938,986465,465337,686977,821474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]