SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001665s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47173 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47173 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407432,130656,774563,102102,41005,86894,1042873,934572,895599,136601,431751,1047865,724178,114685,701269,201028,51831,394215,474176,58646,627713,861864,1005346,474073,602893,115404,14020,59814,366134,427442,260479,208400,785185,315149,48869,479944,301590,95105,853215,45045,929711,287613,808129,451463,181072,675046,532766,373379,369860,276910,909356,314989,217071,361192,1037818,801616,656791,83533,642931,420878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]