SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438515 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438515 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969068,183658,155447,3844,699431,42569,718417,404524,780454,87095,654528,419092,211993,151218,548201,395416,758922,833360,501619,383245,1045628,498625,106265,111741,523049,594769,81803,174014,869961,100328,210110,36043,657389,228231,939744,278835,903015,220911,892271,444866,530542,401467,852852,90955,767360,313041,111042,144016,683087,1031876,592274,171405,340498,860408,24832,446735,887580,449450,1004773,932487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]