SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611818 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611818 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746581,1045937,736612,248101,711075,1041379,970842,674152,673425,149406,557164,47465,879851,221341,136585,214246,177064,1040205,494672,722821,665781,714439,453507,452110,75067,897837,758884,828671,455425,985256,591677,851649,935692,617218,986822,132970,300383,1003682,549379,122824,831033,104351,594715,713784,314944,225046,1030147,994727,104692,73726,385686,972401,711595,48472,761385,317034,789891,127125,809156,612270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]