SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 707411 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 707411 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964620,413808,798041,618037,533580,423596,68063,34488,38813,402497,522698,866036,923809,893178,456571,563291,459403,814161,923808,980691,914718,988449,9579,753174,634586,60605,592700,330402,882583,949475,204388,642846,90661,762520,358520,279957,586213,1046685,3105,948318,545415,800746,962976,151276,339903,618499,586774,270691,526160,945153,675503,130559,349387,287469,357156,778613,627144,508368,322764,527621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 707411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 707411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]