SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10718 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10718 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042529,738719,500327,711853,97610,63469,1011709,155808,828595,553223,676606,681157,486505,769281,176007,773678,216653,662256,1011020,948357,664305,71189,411182,646019,274136,469498,401188,573575,1024999,683468,76896,800323,317831,603959,685929,169018,139694,482105,460300,366466,841024,1038971,59111,466019,917366,859797,833655,318161,225954,299079,231102,417335,431537,575849,144115,22386,903008,524869,879654,641433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]