SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808213 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808213 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337729,166360,563071,882005,418739,737818,589219,176416,1036519,437278,479374,834600,602129,218624,590809,504030,134266,656051,194575,582426,690875,526318,29259,255664,37318,126573,172458,983802,349682,883420,584766,63490,607009,699988,196471,166876,805163,974556,848567,554824,321127,551822,571945,291954,308262,339007,224358,71477,906555,343742,506456,35825,1029684,243071,983719,19489,713067,68817,736161,264802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]