SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513530 LIMIT 1 [ RunTime:0.000792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513530 [ RunTime:0.003419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622297,528213,310375,970847,162572,716719,839593,648564,1002058,61580,405028,731165,502469,776665,700587,341609,156691,415739,886587,161366,387334,663511,881827,873679,949130,570435,840550,100325,557409,259735,346866,294404,540684,221809,754883,945886,798138,1014435,101983,869419,40175,95621,68103,412856,511072,746881,986460,911878,890946,557135,621052,744975,185382,679104,820154,517241,340958,768094,376621,825507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]