SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537291 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537291 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040124,452759,856269,468740,495543,594312,62912,108885,749051,516907,139977,612037,474324,740975,100493,984902,1040337,900459,140889,890212,595324,984630,481698,329994,358266,316569,176852,1022408,849416,919048,56714,932651,855790,493691,699394,635590,954139,995097,511292,922089,858785,5775,1026729,681612,989035,816953,790695,737120,157482,499396,76437,663034,1020351,353381,518242,815700,96150,286268,356538,505694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]