SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022067 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022067 [ RunTime:0.003859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100498,860607,898077,948677,790682,156451,273906,98690,4698,539309,471440,18406,47814,214916,830082,1005655,812647,618978,107997,278278,868637,105809,176626,167107,347425,380164,988137,115853,904744,585786,59961,494878,45435,151538,744924,865607,321450,352487,771518,865169,559063,177569,897648,483003,1020309,789150,387419,952554,617327,235402,139490,826786,355637,117047,488158,458574,741421,691680,115374,261588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002303s ]