SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032100 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032100 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88023,55791,114168,296560,300265,788895,168638,81910,564966,118411,840589,1038683,579162,277907,210352,38043,919083,530793,929962,374383,69895,515223,62165,153675,272050,27912,939366,930165,243427,183396,694481,440839,985085,334039,188315,738432,1007782,584989,382192,855272,242887,474767,958767,269044,380727,222816,503302,209071,287899,435928,350056,848393,957295,851459,232447,193369,261861,842156,675936,821068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]