SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380098 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380098 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593201,109575,308572,568394,231822,377081,715191,1041471,692430,571631,308021,689345,165137,55862,897007,381096,959958,185445,809400,421481,810107,240045,405399,841549,469850,796101,880409,580672,508434,877235,31290,799399,350008,1000855,411641,371987,449910,751491,379887,778007,674806,120760,542877,261384,461424,374383,141102,208572,363030,310407,466370,401890,712019,828916,502073,418936,274394,601679,629437,801881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]