SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528010 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528010 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675959,947803,755129,24562,256366,460372,764969,865247,493217,715881,629950,488430,790005,15658,626640,392579,659107,421825,92700,578882,555001,343156,959929,870143,201597,485805,710341,16317,624699,203347,15974,845360,835409,341303,182394,595058,404291,496615,491785,20548,768840,421170,690724,129126,322708,217623,691493,218455,127179,557357,855077,953024,279973,422573,662916,620279,1005703,805683,592210,275161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]