SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 740963 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 740963 [ RunTime:0.004513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98725,427853,105330,1029999,842362,188800,457994,28732,946756,362789,424542,797552,977781,917784,115551,515169,434519,81261,78950,571001,468697,192778,23780,1042015,810741,657400,273415,341862,62811,53044,272034,111543,986418,338910,772258,412518,675500,623249,302132,748885,666020,107292,552593,320399,749151,328586,674553,962760,13541,35014,525192,837430,197604,985590,1022108,343703,285368,941747,669658,854053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 740963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 740963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]