SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010084 LIMIT 1 [ RunTime:0.002398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010084 [ RunTime:0.005214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880352,351521,958461,408650,368553,20822,923383,46801,348849,827452,761933,470914,748383,45733,890216,320996,21252,325648,317515,520435,246333,290400,764335,921199,650,646253,613572,61328,973208,729093,336584,239843,526014,218936,467872,495097,834589,157932,975004,850703,537729,512218,134569,256970,121399,1041477,145179,292357,193547,1032764,331395,949710,338938,104296,89417,675627,889636,840799,147064,518193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]