SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43294 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43294 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405297,459417,266857,975162,180360,316233,107385,351866,1019029,845294,365546,1010705,184439,521118,953824,465561,610593,398509,98291,826538,504057,196795,365830,672152,827186,589607,170342,1003616,88694,98145,490315,630545,617725,1003533,146512,421947,309024,954873,399635,407245,383322,609918,639334,383607,69577,36972,164979,812051,582163,96396,461693,1031738,391907,603905,74602,349813,586873,158292,990388,756652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]