SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036847 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036847 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808800,260888,989850,86956,273658,661111,735498,422415,613374,343462,876145,411057,127642,300832,254634,915859,1036424,480311,58656,188874,124259,417198,33549,952831,832020,265317,736192,975354,637515,258417,485952,285459,427850,183512,1036974,951998,185769,239067,984728,808624,683328,99679,635497,733033,140228,70681,717015,1028135,259230,525559,1033975,642624,822210,224117,925053,394362,372573,560896,833400,309843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]