SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586906 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586906 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994730,477611,201260,800693,460654,888892,525350,347356,680042,215207,809232,301827,1016054,118062,247952,251043,360102,405343,860682,388433,442748,499844,6744,292308,82827,777639,732723,184080,963628,475975,8513,156673,792792,954697,189826,744714,718146,407604,64423,593002,252441,65300,660402,676157,71574,238257,938580,983163,343505,585303,46137,538859,795984,1046098,390512,134633,395436,984111,675985,581163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]