SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341615 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341615 [ RunTime:0.003780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6509,160377,107041,610356,120490,1019023,723762,281410,799416,926667,802695,699994,958502,124758,497732,488537,759706,970830,404991,306102,216231,972067,483455,961560,555836,402198,823942,301695,933618,855245,936983,332909,692068,515010,63057,488830,687708,690730,958033,86540,507119,365839,17143,372913,922206,436296,736786,152444,1024907,181685,184227,344223,543271,423517,928970,381082,840191,720940,626175,342362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]