SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804210 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804210 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390189,781775,366719,493732,95663,637946,262523,42883,709983,367496,74987,735738,1042104,467629,898389,554709,299833,823178,155220,307088,449670,709960,374357,628791,108346,412074,687958,41006,592409,532571,101178,649545,125668,948359,166914,855008,225788,589928,746044,963837,410975,279305,682089,409445,727666,822089,789058,437374,746100,256758,414573,731001,72967,260570,4756,835424,574794,736544,979218,458395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]