SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553252 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553252 [ RunTime:0.005471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562236,319290,633547,243861,546668,330079,140955,591398,827554,329919,35496,823778,245914,749089,805329,700012,677327,924021,437964,755711,406384,749700,10296,834068,82220,381548,494118,884335,824754,148504,9345,51954,571666,370754,376431,219828,259184,733516,759907,140186,900529,67041,826275,7980,44469,350153,369893,475054,398914,819566,550521,652701,241948,46770,513328,1020870,303377,170873,946409,474692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]