SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566811 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566811 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451133,317127,729865,442452,678551,495382,197464,792338,567690,471742,345771,448287,915108,757761,788078,36089,79028,366161,99581,52881,175107,710045,479810,74731,204748,912536,656535,60662,736784,697935,815040,608187,142262,940825,440895,212510,923687,202154,904045,879033,290400,148461,901812,1008314,550636,697335,902263,365437,932463,385200,608399,1041623,868433,469779,708339,961646,127067,641775,706559,482145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]