SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019981 LIMIT 1 [ RunTime:0.001284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019981 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443847,425153,767183,136767,303565,722061,3622,475168,509359,984562,106704,523428,652216,534319,308071,16878,285354,134745,742835,1022023,550627,419241,826839,214143,942773,774765,423380,63457,478826,590985,194045,313968,847175,552082,381374,1042884,477434,655184,414502,709752,1017090,250648,87656,663540,694699,153075,887349,175718,739165,983863,34363,247484,542777,329415,190010,828642,253411,818175,484083,863669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]