SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561711 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561711 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559866,873698,336372,87811,290384,816674,446827,503799,949314,672950,714622,54277,153737,974982,815811,346971,344677,708659,605480,611859,748590,74712,791798,191151,234199,992712,971926,871961,546280,895181,819874,869009,446494,27330,872937,808899,182549,554459,821671,818078,723025,1014202,506480,715699,273151,943691,533279,99594,756902,788359,725161,503962,527880,158834,754828,699296,454322,269457,622802,2487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]