SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108319 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108319 [ RunTime:0.005950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415523,956571,612926,47508,81069,323031,461303,138973,394019,562765,723761,194353,860991,940045,917192,507657,718652,157701,129557,327164,1009613,868427,697092,387194,349852,36840,351137,1043673,607371,727814,67461,50212,571025,402727,361864,461110,36070,186630,425253,62739,890376,944241,319299,564523,720348,790349,563705,686615,750945,107185,9455,768935,180045,372610,715348,1005861,61779,504039,89096,811287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001255s ]