SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047364 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047364 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78007,18443,142374,299618,158945,254667,1016063,395594,229358,355331,460826,162845,405753,215915,383133,86209,624238,844268,798723,351591,206973,463233,117379,547602,122062,836292,1001554,154114,916099,484666,110867,20160,973975,901399,935493,779186,136927,980126,101742,986355,107088,736862,296176,27546,920837,250660,410104,491421,83508,74070,942555,518417,398603,165007,122930,622493,176644,202057,594969,168298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]