SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503517 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503517 [ RunTime:0.003381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495051,389052,202934,320608,439399,233613,488037,505840,349080,490683,150990,710747,102800,364811,30356,930246,264425,437648,309726,1046628,70661,392475,1010492,527149,444260,36446,33950,426469,194183,1032419,71562,397515,271403,430541,56923,323681,779529,377305,999919,592685,595875,766395,831045,83178,977457,485523,904626,395602,50879,147584,760146,444967,425217,604248,347679,683358,495832,1001586,487091,811590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]