SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043752 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043752 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269807,507888,296962,729481,704445,547238,205853,107987,248149,62500,994920,276657,186286,936549,86988,547479,142439,965092,802514,791172,540734,57008,6083,237902,86357,729987,722080,537204,383147,89296,176686,524159,468118,89911,378993,184292,1004828,273024,712428,825557,1019809,377923,922885,27937,425419,1038922,407362,544649,631815,186409,27126,1046336,218151,174127,586205,463858,2079,87719,651462,321307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]