SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011683 LIMIT 1 [ RunTime:0.001766s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011683 [ RunTime:0.003271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18786,745170,427965,1038107,508170,120819,481668,585200,573841,990556,962321,248042,635935,893132,1019798,109914,189370,18269,705705,343129,909205,313572,704493,795040,582291,277830,951174,802115,747161,166570,379074,14644,863819,139275,974580,128964,951478,1011021,599323,1006027,262753,940249,31342,908159,698934,27834,951600,66822,91757,273412,622487,310654,241409,239609,928480,902216,601051,595046,254473,494477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]