SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036118 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036118 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207120,110680,546006,884023,589740,814571,425713,1042344,628072,102740,418094,421668,765573,183981,79614,246382,437788,922178,989202,1034813,280765,40884,150875,458276,452262,210977,676335,454356,543937,606783,948962,1040673,557624,914178,224658,762605,719365,59174,27141,712842,474390,400632,556690,856909,588095,256004,624904,148555,766779,641249,416238,774503,888519,524886,297652,471894,570087,495575,70074,727440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]