SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916828 LIMIT 1 [ RunTime:0.003821s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916828 [ RunTime:0.003617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4547,410332,490016,236644,502535,573658,564411,806441,813324,187703,704413,703438,908279,227572,760530,10413,65493,716321,949570,413428,428680,10080,828807,374055,826414,396776,986003,486446,1008539,888228,224462,881876,876278,215303,575093,775354,399330,470481,666976,586118,539225,2608,603007,304152,528061,498351,737923,576499,117009,967951,227989,789266,644354,770497,737330,539791,900275,908906,103731,1010889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]