SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599092 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599092 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189198,698965,192754,641683,193641,57211,579805,33764,471947,943160,532443,173031,651512,353951,218644,639497,971600,575616,422646,337860,372669,559048,572019,796919,397307,266028,251754,354609,322611,84719,583014,736403,562089,593456,1023358,786943,254098,205484,283133,404083,940473,907712,545483,425754,781088,89728,177100,7173,528399,850137,269285,81698,771452,902189,731912,415049,307542,991538,152469,826596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]