SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413958 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413958 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840328,96758,1005432,839368,585099,11432,465522,490777,990056,572086,107257,322558,546292,643068,554097,407607,281418,600701,670003,155329,683566,969418,1022763,254999,754218,68283,426839,986702,829807,644545,520772,695166,253885,175739,318718,888812,103930,107035,87058,897664,767205,664637,215536,361155,198930,763650,919399,204012,3951,930312,168099,644270,48559,47768,893818,767900,971633,1000173,248559,989679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]