SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535016 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535016 [ RunTime:0.002041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993576,906662,884914,323781,1006083,64442,839,411185,752143,783836,589669,681745,45771,683914,593838,263495,648351,942942,57660,358660,578352,546489,797132,986254,72032,39578,393478,874519,93479,61453,420795,634683,161720,614095,998739,792621,899298,770318,993132,354176,822360,950535,645682,284697,811511,787111,899312,405121,39876,678389,925239,339374,708245,568603,1037114,865354,410631,355148,284854,786515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]