SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501700 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501700 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373626,607199,22838,918519,924882,702915,538967,409398,104262,118764,577299,942428,910817,852286,750929,341093,687413,177222,705063,314958,624531,979614,372485,119389,624638,963943,316515,988654,596158,60210,808408,806059,317260,1043714,791432,766751,458726,641798,185079,551924,552947,124473,47381,646639,870597,903283,928962,88660,648915,464049,971210,125691,688390,833714,466518,605053,578715,174651,245823,376424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]