SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024075 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024075 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738167,738359,431823,679999,28546,197366,725334,543145,750989,27050,862995,321334,274563,344167,114143,938614,391716,377429,39658,670426,1047741,1005178,722599,1906,306350,450335,796373,223028,896234,275720,442932,250173,474802,599315,947655,39364,841889,1035798,635831,558642,724158,837297,502698,670542,506997,81745,832267,563419,389856,920550,988612,1003422,315558,411750,450184,554948,932817,101016,496305,656821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000827s ]