SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511681 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511681 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909530,113318,386217,157454,892003,131889,4909,478263,775289,465000,365631,431210,1045105,753704,205888,614516,591218,1030818,423736,143708,398235,419043,130520,766239,161392,746824,1040422,51431,497464,905729,392005,697063,62417,756011,287050,144741,248314,809144,92253,755583,627996,67612,939771,671411,1016188,714163,365836,874427,215338,404992,278013,725621,915704,164007,282500,720139,750837,675049,552374,72355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]