SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404110 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404110 [ RunTime:0.005618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942018,677126,937695,160688,438207,725334,285303,934608,46103,338244,1001846,60892,276495,643027,784099,891556,492129,363225,37003,530529,697315,241391,115332,37704,138667,158393,19099,649655,879136,523573,206926,196583,608897,365391,297470,572569,419392,110513,456140,941532,218330,616835,802621,939911,841452,664195,14710,735365,796371,361229,519986,1021046,765165,633784,524714,588295,947437,866800,364360,764120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]