SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910452 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910452 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729307,97518,780423,246041,860683,393005,713988,334421,969288,588688,53555,962011,1027649,256725,137999,173011,38132,1043414,153017,433508,81226,267350,620211,350120,948299,588756,663788,881277,745815,196871,381034,1037661,107274,1005754,971618,336954,685894,326253,733796,648346,520496,900078,945987,131336,23857,245820,56538,621690,299638,736647,893644,878620,338065,641060,353940,630872,761182,318750,711612,853324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]