SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48912 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48912 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3880,725929,741494,990003,303136,809562,774715,34287,161694,163014,1040188,568856,902024,1023078,457911,97690,211716,549681,154676,294256,22501,688450,819496,9310,851562,437505,410869,14825,682876,324817,169591,224102,660324,793054,163239,765942,198046,823435,10785,782062,258456,840903,404793,731043,568939,1003778,383146,994756,281806,429148,811060,970911,628324,396997,155131,162141,191836,542348,591492,975548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]