SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201162 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201162 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87415,962588,446779,285660,951699,729133,724655,689260,881454,982534,308758,156217,677576,1038855,366822,107630,786188,260330,610285,384956,377744,499045,520295,773317,154961,186431,1009405,594595,864827,213446,29442,142752,715713,160708,125512,656355,748457,90204,1029221,609664,369011,994476,743167,859368,95527,643577,283701,991293,596221,354129,727568,818649,85501,542943,813711,172623,926398,72881,695172,619289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]