SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317294 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317294 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34575,269096,180013,691635,26416,551242,707571,818662,849029,631978,102345,61626,293523,777413,782961,1035380,37056,28371,888163,802926,861082,1033440,386916,423972,446588,716240,852184,91593,969823,160824,717592,100976,365062,1018054,51160,679775,506061,155232,877235,599849,464703,933197,93014,335924,129892,664244,430622,413503,413361,641849,244722,829058,495824,508854,100009,407050,771560,680766,673121,765362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]