SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017341 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017341 [ RunTime:0.002869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61818,856494,28601,215783,589593,279921,131488,41985,723504,855345,465614,977763,952385,331108,985834,56746,977087,80210,877113,483566,529380,84746,200718,409370,161681,752874,377941,817438,749975,753954,63358,144133,214123,926820,438537,537067,144635,611780,538036,555358,105111,652641,899769,68292,141364,146378,888490,913922,934285,479947,116141,137869,229292,782030,202213,546211,350836,669847,108233,860736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]