SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436668 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436668 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662803,256503,289722,562836,806614,550720,780890,725975,732470,299901,768858,8616,46509,312991,889302,20561,414390,159319,953891,976205,492884,747322,577899,1023594,264491,535119,244352,948134,432639,197326,675191,277175,567486,229486,122873,380196,256012,604568,764096,570136,16472,494313,21158,20152,779608,850894,874591,1028562,342058,584292,25788,633180,574525,639651,391121,822751,1045196,925458,862344,669327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]