SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110104 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110104 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004419,352858,288070,32125,346831,872946,541397,108617,131539,33812,653066,987836,841287,451239,134605,1031026,49984,379196,377812,787216,758447,1044199,214110,538027,453341,454341,930233,654016,180602,63511,388827,964485,75677,559238,806558,648221,967172,1010598,229575,210610,102647,894159,915550,177231,12400,503538,538844,313626,475077,51256,825035,896315,16923,232740,930230,520763,761392,854755,775272,370877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]