SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037754 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037754 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168411,818852,923867,460692,1021711,712158,192113,703783,444491,678574,160709,934125,423971,213136,1043721,798162,677878,208402,730054,450197,291591,595555,8942,738518,229177,10188,548759,43622,347128,509853,484074,591791,1045170,888152,371243,98912,237045,873928,931890,690599,93677,980748,754450,268811,121942,923789,117393,706928,707191,801708,76636,278527,653621,365054,928269,158252,693864,123977,926467,976023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001180s ]