SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414409 LIMIT 1 [ RunTime:0.003617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414409 [ RunTime:0.006404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045689,409547,64260,222269,427055,159525,824654,766910,879258,350166,541394,515784,367922,1025963,211580,22215,450776,751765,385723,969867,500731,430409,640227,132544,832192,1017846,330834,770998,275625,211930,355778,723691,230786,772316,974016,56933,349845,330686,920627,968554,691345,4969,70885,103493,634062,663785,583108,303642,20226,814036,792884,13453,187165,287710,364820,292014,986034,352552,817558,60631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001047s ]