SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519110 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519110 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521614,325919,678829,338150,394007,460130,949647,27204,916054,1034104,853135,887220,519666,595053,228374,277614,702069,155763,966117,845903,526297,750055,466218,977352,316508,548751,920905,795810,515995,822633,269604,623764,937269,985604,730583,959145,430381,845490,153947,375670,469508,349717,707756,312040,215956,904657,395458,880513,698934,141670,121827,674419,691653,230303,82211,512367,34298,221109,544053,244454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]