SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002816s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410226 LIMIT 1 [ RunTime:0.001004s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410226 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122227,405440,958872,366983,694244,1040950,587840,122417,808503,438319,418402,665278,1023644,781649,964239,223696,956655,394896,861210,905807,761151,409429,22971,907164,86361,941964,713083,159469,23943,826807,502741,929113,184486,683179,348089,920263,761133,157032,331161,674254,548712,334629,402294,497448,589265,932203,666602,263823,829639,1027904,451811,127753,790476,999480,1019539,994174,572483,766760,920628,128960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]