SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59794 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59794 [ RunTime:0.003722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833679,810925,278497,928915,278265,888794,729684,902084,251895,852656,707776,732612,208972,717676,88546,483848,128931,93033,765795,340199,336879,180708,797963,397675,409640,489501,51861,30861,650361,336532,717146,858735,967343,434647,359659,593350,400439,33422,651811,867035,568158,12399,233520,329396,568862,145567,517653,597196,323654,764412,351229,16759,392391,761001,790992,563931,783418,1018588,1039450,219925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001641s ]