SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564897 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564897 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809473,284743,1003606,155618,811315,13981,35662,62521,112217,821132,771261,389435,726101,213152,513424,1013514,85212,605474,881349,818071,41583,57189,284772,781609,1047425,114053,324404,76823,593747,366925,941928,524378,1043359,258573,127587,18474,258563,960271,100566,632054,911186,1041396,671862,156437,60176,338452,726118,908615,797410,469053,806328,230717,703406,549090,412297,91261,81324,302551,647773,505229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001530s ]