SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541218 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541218 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700564,752524,107045,968158,566680,75886,653220,769260,349791,440536,621691,575854,214860,240571,427476,479862,236689,133521,782627,547381,136133,308360,960033,70686,33884,444051,641709,1016979,267004,694532,1035690,912269,984121,122582,234567,322560,215444,219315,808683,758469,690496,728569,532548,744742,166459,748375,168206,648578,569765,650896,402781,482492,220767,408604,69731,322533,188583,118610,363740,180423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]