SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319678 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319678 [ RunTime:0.003213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413320,97871,568620,781935,97136,554489,991305,798543,371183,349153,375640,675866,574626,81387,87205,447324,538741,411957,897674,520922,723516,847628,1023029,131455,456766,969628,490341,487205,88407,900385,937469,611811,366069,868257,135341,108691,577732,2937,814831,815237,711759,578674,309526,601662,856212,1017431,166023,840508,556836,133004,930496,126817,102705,342582,686998,123107,969365,241954,307102,865370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]