SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018697 LIMIT 1 [ RunTime:0.001406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018697 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71460,836059,574436,478625,789144,457772,124535,701860,350625,614110,791961,257830,198546,266103,950894,875625,70363,113269,973755,579578,650018,259592,11461,26513,131653,202294,272560,1006225,1001993,1034357,262986,54549,750308,915581,969618,476169,518036,92401,436101,211424,782325,210458,640400,351818,177639,67589,870918,555520,914955,356997,325085,823747,748868,926725,525059,390306,514850,300925,742004,694167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]