SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040949 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040949 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522916,818460,885739,254517,376183,627961,432746,357384,350532,647602,904554,776213,861816,401464,947404,886420,1005340,903346,1011664,119100,672093,821255,847947,1008369,134411,563381,183476,104083,735517,391302,908542,696187,121462,1021505,645317,295059,801220,142192,611764,450542,927329,543212,478577,45773,242665,934982,86276,573475,79798,1036024,1036021,926543,73048,956325,19691,314239,202613,318563,497593,71284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]